

USE [Dosimetria]
GO

/****** Object:  Table [dbo].[HCD_dosimetros]    Script Date: 09/09/2013 11:53:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[HCD_dosimetros](
	[id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[DFUN_COD] NUMERIC(10,0) NOT NULL,
	[DFUN_NUM] NUMERIC(10,0) NOT NULL,
	[DOSIM_TIPO] VARCHAR(5),
	[Cod_Contrato] NUMERIC(10,0) NULL,
	[Fecha_Envio_Dosimetro] VARCHAR(15) NULL,
	[HCD_id] INT NOT NULL REFERENCES HCD(ID),
	[devuelto] bit NULL,
	[daniado] bit NULL,
	[extraviado] bit NULL,
	[sin_uso] bit NULL,
	[reasignado] bit NULL,
	[fin_control] bit NULL,
	[observacion] VARCHAR(80) NULL,
	[fecha_recepcion] VARCHAR(15) NULL,
    [FUNC_COD] NUMERIC(10,0) NULL
	);

GO

SET ANSI_PADDING OFF
GO

